package com.hp.service;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import com.hp.entity.Employee;
import org.apache.ibatis.annotations.Select;

public interface EmployeeService  extends IService<Employee> {

    //分页查询所有员工（倒序）
    Page<Employee> selectListByPage(int pageNo);

    //查询编号最大的员工编号,
    @Select("SELECT MAX(employee.`employee_number`) FROM employee")
    Integer selectMaxNum();

    /*根据传入的employee对象返回一个完整对象信息*/
    Employee selectEmployee(Employee employee);
}
